Sort Registry entry

Records what columns to sort, and whether to sort in ascending or descending order. (This Registry entry is generated and maintained by the System when a Sort is defined in a module).

Description

Users can create and save their own set of rules used for sorting data. The Sort Registry entry records which columns to sort, and whether to sort in ascending or descending order. A user can choose which Sort definition to use from the Sort box by selecting Sort on the Home tab of the Ribbon.

The currently selected Sort for a user is recorded in the Sort Selected Registry entry.

Usage

This Registry entry can be assigned to users and groups:

Key User Group Group
Key 1 User Group Group
Key 2 user group Default
Key 3 Table
Key 4 table
Key 5 Sort
Key 6 title
Value rules

where:

title

is a name for the Sort. It displays in the Sort box when listing all defined Sort entries available to a user.

rules

is in the format:

xcolumn;xcolumn;...

where the value for x is either + or - indicating an ascending or descending ordered sort respectively; column is the name of a back-end field.

The records will be sorted on the first column, and any records with the same value in the first column will be sorted by the second column, and so on.

Example

This entry specifies a Sort for user gerard in the Parties module. The entry defines an ascending sort on the AddPhysCity field, with a secondary descending order sort on the AddPhysState field:

Key Setting
Key 1 User
Key 2 gerard
Key 3 Table
Key 4 eparties
Key 5 Sort
Key 6 Address
Value +AddPhysCity;-AddPhysState